About
Column {data-width=400, vertical_layout: scroll}
Purpose of the dashboard
The dashboard is to examine hotel cancellations and factors associated with hotel cancellations in the United States between 2015 and 2017.
Column {data-width=400, overflow-x: auto, vertical_layout: scroll}
Original Data
The dataset is included in TidyTuesday, 2020-02-11. The original dataset comes from an open hotel booking demand dataset from Antonio, Almeida and Nunes, 2019. This dataset includes bookings of resort hotels or city hotels between the 1st of July of 2015 and the 31st of August 2017, including bookings that effectively arrived and bookings that were canceled.
The Data
Column
Data Dictionary
Glimpse of the Dataset
Column {data-width=350, overflow-x: auto, vertical_layout: scroll}
Characteristics of hotel bookings overall and by cancellation
| Overall (N=2097) |
No (N=1596) |
Yes (N=501) |
|
|---|---|---|---|
| Type of hotel | |||
| City Hotel | 1618 (77.2%) | 1189 (74.5%) | 429 (85.6%) |
| Resort Hotel | 479 (22.8%) | 407 (25.5%) | 72 (14.4%) |
| Number of days between booking and arrival | |||
| Mean (SD) | 77.2 (82.7) | 70.7 (82.6) | 97.8 (79.8) |
| Median [Min, Max] | 51.0 [0, 542] | 40.0 [0, 542] | 77.0 [0, 327] |
| Year of arrival date | |||
| 2015 | 180 (8.6%) | 180 (11.3%) | 0 (0%) |
| 2016 | 963 (45.9%) | 748 (46.9%) | 215 (42.9%) |
| 2017 | 954 (45.5%) | 668 (41.9%) | 286 (57.1%) |
| Season of arrival date | |||
| Spring | 589 (28.1%) | 426 (26.7%) | 163 (32.5%) |
| Summer | 851 (40.6%) | 616 (38.6%) | 235 (46.9%) |
| Fall | 412 (19.6%) | 354 (22.2%) | 58 (11.6%) |
| Winter | 245 (11.7%) | 200 (12.5%) | 45 (9.0%) |
| Number of weekend nights stayed | |||
| Mean (SD) | 0.855 (0.929) | 0.812 (0.921) | 0.992 (0.942) |
| Median [Min, Max] | 1.00 [0, 13.0] | 1.00 [0, 13.0] | 1.00 [0, 5.00] |
| Number of week nights stayed | |||
| Mean (SD) | 1.92 (1.67) | 1.83 (1.64) | 2.21 (1.73) |
| Median [Min, Max] | 2.00 [0, 30.0] | 1.00 [0, 30.0] | 2.00 [0, 11.0] |
| Number of adults | |||
| Mean (SD) | 1.88 (0.526) | 1.86 (0.521) | 1.95 (0.535) |
| Median [Min, Max] | 2.00 [0, 4.00] | 2.00 [0, 4.00] | 2.00 [0, 3.00] |
| Number of children and babies | |||
| Mean (SD) | 0.175 (0.534) | 0.150 (0.492) | 0.255 (0.644) |
| Median [Min, Max] | 0 [0, 3.00] | 0 [0, 3.00] | 0 [0, 2.00] |
| Repeated guest | |||
| No | 2078 (99.1%) | 1578 (98.9%) | 500 (99.8%) |
| Yes | 19 (0.9%) | 18 (1.1%) | 1 (0.2%) |
| Number of changes to the booking | |||
| Mean (SD) | 0.339 (0.866) | 0.367 (0.922) | 0.250 (0.654) |
| Median [Min, Max] | 0 [0, 14.0] | 0 [0, 14.0] | 0 [0, 5.00] |
| Average daily rate, $ | |||
| Mean (SD) | 123 (51.6) | 119 (51.4) | 136 (50.1) |
| Median [Min, Max] | 115 [0, 328] | 109 [0, 328] | 128 [0, 311] |
Categorical Characteristics of bookings by cancellation
Column
Number of completed and cancelled hotel bookings by season and year
Number of completed and cancelled hotel bookings by hotel type
Continuous Characteristics of bookings by cancellation
Column
Average daily rate and time before arrival
Other continuous characteristics
